﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="YiLeSystemData" targetNamespace="http://tempuri.org/YiLeSystemData.xsd" xmlns:mstns="http://tempuri.org/YiLeSystemData.xsd" xmlns="http://tempuri.org/YiLeSystemData.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="YiLeSystemConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="YiLeSystemConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.YiLe.Properties.Settings.GlobalReference.Default.YiLeSystemConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Xs_OrderTableAdapter" GeneratorDataComponentClassName="Xs_OrderTableAdapter" Name="Xs_Order" UserDataComponentName="Xs_OrderTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="YiLeSystemConnectionString (Settings)" DbObjectName="CanyinSystem.dbo.Xs_Order" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Xs_Order] WHERE (([OrderId] = @Original_OrderId) AND ([TableId] = @Original_TableId) AND ([OrderTime] = @Original_OrderTime) AND ([EmployeeNum] = @Original_EmployeeNum) AND ([PeopleNum] = @Original_PeopleNum))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TableId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TableId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_OrderTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PeopleNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeopleNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Xs_Order] ([OrderId], [TableId], [OrderTime], [EmployeeNum], [PeopleNum]) VALUES (@OrderId, @TableId, @OrderTime, @EmployeeNum, @PeopleNum);
SELECT OrderId, TableId, OrderTime, EmployeeNum, PeopleNum FROM Xs_Order WHERE (OrderId = @OrderId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TableId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TableId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@OrderTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PeopleNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeopleNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT *
FROM Xs_Order</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Xs_Order] SET [OrderId] = @OrderId, [TableId] = @TableId, [OrderTime] = @OrderTime, [EmployeeNum] = @EmployeeNum, [PeopleNum] = @PeopleNum WHERE (([OrderId] = @Original_OrderId) AND ([TableId] = @Original_TableId) AND ([OrderTime] = @Original_OrderTime) AND ([EmployeeNum] = @Original_EmployeeNum) AND ([PeopleNum] = @Original_PeopleNum));
SELECT OrderId, TableId, OrderTime, EmployeeNum, PeopleNum FROM Xs_Order WHERE (OrderId = @OrderId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TableId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TableId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@OrderTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PeopleNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeopleNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TableId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TableId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_OrderTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PeopleNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeopleNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrderId" DataSetColumn="OrderId" />
              <Mapping SourceColumn="TableId" DataSetColumn="TableId" />
              <Mapping SourceColumn="OrderTime" DataSetColumn="OrderTime" />
              <Mapping SourceColumn="EmployeeNum" DataSetColumn="EmployeeNum" />
              <Mapping SourceColumn="PeopleNum" DataSetColumn="PeopleNum" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Xs_OrderDetailTableAdapter" GeneratorDataComponentClassName="Xs_OrderDetailTableAdapter" Name="Xs_OrderDetail" UserDataComponentName="Xs_OrderDetailTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="YiLeSystemConnectionString (Settings)" DbObjectName="CanyinSystem.dbo.Xs_OrderDetail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Xs_OrderDetail] WHERE (([OrderDetailId] = @Original_OrderDetailId) AND ([OrderId] = @Original_OrderId) AND ([FoodID] = @Original_FoodID) AND ([FoodNum] = @Original_FoodNum) AND ([FoodPrice] = @Original_FoodPrice))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderDetailId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDetailId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FoodID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FoodNum" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FoodNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FoodPrice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FoodPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Xs_OrderDetail] ([OrderDetailId], [OrderId], [FoodID], [FoodNum], [FoodPrice]) VALUES (@OrderDetailId, @OrderId, @FoodID, @FoodNum, @FoodPrice);
SELECT OrderDetailId, OrderId, FoodID, FoodNum, FoodPrice FROM Xs_OrderDetail WHERE (OrderDetailId = @OrderDetailId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderDetailId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDetailId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FoodID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FoodNum" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FoodNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FoodPrice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FoodPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Xs_OrderDetail.*
FROM Xs_OrderDetail</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Xs_OrderDetail] SET [OrderDetailId] = @OrderDetailId, [OrderId] = @OrderId, [FoodID] = @FoodID, [FoodNum] = @FoodNum, [FoodPrice] = @FoodPrice WHERE (([OrderDetailId] = @Original_OrderDetailId) AND ([OrderId] = @Original_OrderId) AND ([FoodID] = @Original_FoodID) AND ([FoodNum] = @Original_FoodNum) AND ([FoodPrice] = @Original_FoodPrice));
SELECT OrderDetailId, OrderId, FoodID, FoodNum, FoodPrice FROM Xs_OrderDetail WHERE (OrderDetailId = @OrderDetailId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderDetailId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDetailId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FoodID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FoodNum" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FoodNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@FoodPrice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FoodPrice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderDetailId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderDetailId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FoodID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FoodNum" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FoodNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_FoodPrice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="FoodPrice" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrderDetailId" DataSetColumn="OrderDetailId" />
              <Mapping SourceColumn="OrderId" DataSetColumn="OrderId" />
              <Mapping SourceColumn="FoodID" DataSetColumn="FoodID" />
              <Mapping SourceColumn="FoodNum" DataSetColumn="FoodNum" />
              <Mapping SourceColumn="FoodPrice" DataSetColumn="FoodPrice" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EmployeeTableAdapter" GeneratorDataComponentClassName="EmployeeTableAdapter" Name="Employee" UserDataComponentName="EmployeeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="YiLeSystemConnectionString (Settings)" DbObjectName="CanyinSystem.dbo.Employee" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Employee] WHERE (([EmployeeNum] = @Original_EmployeeNum) AND ([RealName] = @Original_RealName) AND ([Sex] = @Original_Sex) AND ([EmployeeState] = @Original_EmployeeState) AND ([DepartmentId] = @Original_DepartmentId) AND ([CreatTime] = @Original_CreatTime))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_RealName" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="RealName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_EmployeeState" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Employee] ([EmployeeNum], [RealName], [Sex], [Tel], [Adress], [EmployeeState], [DepartmentId], [CreatTime]) VALUES (@EmployeeNum, @RealName, @Sex, @Tel, @Adress, @EmployeeState, @DepartmentId, @CreatTime);
SELECT EmployeeNum, RealName, Sex, Tel, Adress, EmployeeState, DepartmentId, CreatTime FROM Employee WHERE (EmployeeNum = @EmployeeNum)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@RealName" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="RealName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@EmployeeState" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Employee.*
FROM Employee</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Employee] SET [EmployeeNum] = @EmployeeNum, [RealName] = @RealName, [Sex] = @Sex, [Tel] = @Tel, [Adress] = @Adress, [EmployeeState] = @EmployeeState, [DepartmentId] = @DepartmentId, [CreatTime] = @CreatTime WHERE (([EmployeeNum] = @Original_EmployeeNum) AND ([RealName] = @Original_RealName) AND ([Sex] = @Original_Sex) AND ([EmployeeState] = @Original_EmployeeState) AND ([DepartmentId] = @Original_DepartmentId) AND ([CreatTime] = @Original_CreatTime));
SELECT EmployeeNum, RealName, Sex, Tel, Adress, EmployeeState, DepartmentId, CreatTime FROM Employee WHERE (EmployeeNum = @EmployeeNum)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@RealName" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="RealName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Tel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Tel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adress" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@EmployeeState" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeNum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmployeeNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_RealName" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="RealName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_EmployeeState" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="EmployeeState" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EmployeeNum" DataSetColumn="EmployeeNum" />
              <Mapping SourceColumn="RealName" DataSetColumn="RealName" />
              <Mapping SourceColumn="Sex" DataSetColumn="Sex" />
              <Mapping SourceColumn="Tel" DataSetColumn="Tel" />
              <Mapping SourceColumn="Adress" DataSetColumn="Adress" />
              <Mapping SourceColumn="EmployeeState" DataSetColumn="EmployeeState" />
              <Mapping SourceColumn="DepartmentId" DataSetColumn="DepartmentId" />
              <Mapping SourceColumn="CreatTime" DataSetColumn="CreatTime" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="YiLeSystemData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="YiLeSystemData" msprop:Generator_UserDSName="YiLeSystemData">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Xs_Order" msprop:Generator_TableClassName="Xs_OrderDataTable" msprop:Generator_TableVarName="tableXs_Order" msprop:Generator_TablePropName="Xs_Order" msprop:Generator_RowDeletingName="Xs_OrderRowDeleting" msprop:Generator_UserTableName="Xs_Order" msprop:Generator_RowChangingName="Xs_OrderRowChanging" msprop:Generator_RowEvHandlerName="Xs_OrderRowChangeEventHandler" msprop:Generator_RowDeletedName="Xs_OrderRowDeleted" msprop:Generator_RowEvArgName="Xs_OrderRowChangeEvent" msprop:Generator_RowChangedName="Xs_OrderRowChanged" msprop:Generator_RowClassName="Xs_OrderRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrderId" msprop:Generator_ColumnVarNameInTable="columnOrderId" msprop:Generator_ColumnPropNameInRow="OrderId" msprop:Generator_ColumnPropNameInTable="OrderIdColumn" msprop:Generator_UserColumnName="OrderId" type="xs:int" />
              <xs:element name="TableId" msprop:Generator_ColumnVarNameInTable="columnTableId" msprop:Generator_ColumnPropNameInRow="TableId" msprop:Generator_ColumnPropNameInTable="TableIdColumn" msprop:Generator_UserColumnName="TableId" type="xs:int" />
              <xs:element name="OrderTime" msprop:Generator_ColumnVarNameInTable="columnOrderTime" msprop:Generator_ColumnPropNameInRow="OrderTime" msprop:Generator_ColumnPropNameInTable="OrderTimeColumn" msprop:Generator_UserColumnName="OrderTime" type="xs:dateTime" />
              <xs:element name="EmployeeNum" msprop:Generator_ColumnVarNameInTable="columnEmployeeNum" msprop:Generator_ColumnPropNameInRow="EmployeeNum" msprop:Generator_ColumnPropNameInTable="EmployeeNumColumn" msprop:Generator_UserColumnName="EmployeeNum" type="xs:int" />
              <xs:element name="PeopleNum" msprop:Generator_ColumnVarNameInTable="columnPeopleNum" msprop:Generator_ColumnPropNameInRow="PeopleNum" msprop:Generator_ColumnPropNameInTable="PeopleNumColumn" msprop:Generator_UserColumnName="PeopleNum" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Xs_OrderDetail" msprop:Generator_TableClassName="Xs_OrderDetailDataTable" msprop:Generator_TableVarName="tableXs_OrderDetail" msprop:Generator_TablePropName="Xs_OrderDetail" msprop:Generator_RowDeletingName="Xs_OrderDetailRowDeleting" msprop:Generator_UserTableName="Xs_OrderDetail" msprop:Generator_RowChangingName="Xs_OrderDetailRowChanging" msprop:Generator_RowEvHandlerName="Xs_OrderDetailRowChangeEventHandler" msprop:Generator_RowDeletedName="Xs_OrderDetailRowDeleted" msprop:Generator_RowEvArgName="Xs_OrderDetailRowChangeEvent" msprop:Generator_RowChangedName="Xs_OrderDetailRowChanged" msprop:Generator_RowClassName="Xs_OrderDetailRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrderDetailId" msprop:Generator_ColumnVarNameInTable="columnOrderDetailId" msprop:Generator_ColumnPropNameInRow="OrderDetailId" msprop:Generator_ColumnPropNameInTable="OrderDetailIdColumn" msprop:Generator_UserColumnName="OrderDetailId" type="xs:int" />
              <xs:element name="OrderId" msprop:Generator_ColumnVarNameInTable="columnOrderId" msprop:Generator_ColumnPropNameInRow="OrderId" msprop:Generator_ColumnPropNameInTable="OrderIdColumn" msprop:Generator_UserColumnName="OrderId" type="xs:int" />
              <xs:element name="FoodID" msprop:Generator_ColumnVarNameInTable="columnFoodID" msprop:Generator_ColumnPropNameInRow="FoodID" msprop:Generator_ColumnPropNameInTable="FoodIDColumn" msprop:Generator_UserColumnName="FoodID" type="xs:int" />
              <xs:element name="FoodNum" msprop:Generator_ColumnVarNameInTable="columnFoodNum" msprop:Generator_ColumnPropNameInRow="FoodNum" msprop:Generator_ColumnPropNameInTable="FoodNumColumn" msprop:Generator_UserColumnName="FoodNum" type="xs:decimal" />
              <xs:element name="FoodPrice" msprop:Generator_ColumnVarNameInTable="columnFoodPrice" msprop:Generator_ColumnPropNameInRow="FoodPrice" msprop:Generator_ColumnPropNameInTable="FoodPriceColumn" msprop:Generator_UserColumnName="FoodPrice" type="xs:decimal" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Employee" msprop:Generator_TableClassName="EmployeeDataTable" msprop:Generator_TableVarName="tableEmployee" msprop:Generator_TablePropName="Employee" msprop:Generator_RowDeletingName="EmployeeRowDeleting" msprop:Generator_UserTableName="Employee" msprop:Generator_RowChangingName="EmployeeRowChanging" msprop:Generator_RowEvHandlerName="EmployeeRowChangeEventHandler" msprop:Generator_RowDeletedName="EmployeeRowDeleted" msprop:Generator_RowEvArgName="EmployeeRowChangeEvent" msprop:Generator_RowChangedName="EmployeeRowChanged" msprop:Generator_RowClassName="EmployeeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EmployeeNum" msprop:Generator_ColumnVarNameInTable="columnEmployeeNum" msprop:Generator_ColumnPropNameInRow="EmployeeNum" msprop:Generator_ColumnPropNameInTable="EmployeeNumColumn" msprop:Generator_UserColumnName="EmployeeNum" type="xs:int" />
              <xs:element name="RealName" msprop:Generator_ColumnVarNameInTable="columnRealName" msprop:Generator_ColumnPropNameInRow="RealName" msprop:Generator_ColumnPropNameInTable="RealNameColumn" msprop:Generator_UserColumnName="RealName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnPropNameInTable="SexColumn" msprop:Generator_UserColumnName="Sex" type="xs:int" />
              <xs:element name="Tel" msprop:Generator_ColumnVarNameInTable="columnTel" msprop:Generator_ColumnPropNameInRow="Tel" msprop:Generator_ColumnPropNameInTable="TelColumn" msprop:Generator_UserColumnName="Tel">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Adress" msprop:Generator_ColumnVarNameInTable="columnAdress" msprop:Generator_ColumnPropNameInRow="Adress" msprop:Generator_ColumnPropNameInTable="AdressColumn" msprop:Generator_UserColumnName="Adress">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmployeeState" msprop:Generator_ColumnVarNameInTable="columnEmployeeState" msprop:Generator_ColumnPropNameInRow="EmployeeState" msprop:Generator_ColumnPropNameInTable="EmployeeStateColumn" msprop:Generator_UserColumnName="EmployeeState">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DepartmentId" msprop:Generator_ColumnVarNameInTable="columnDepartmentId" msprop:Generator_ColumnPropNameInRow="DepartmentId" msprop:Generator_ColumnPropNameInTable="DepartmentIdColumn" msprop:Generator_UserColumnName="DepartmentId" type="xs:int" />
              <xs:element name="CreatTime" msprop:Generator_ColumnVarNameInTable="columnCreatTime" msprop:Generator_ColumnPropNameInRow="CreatTime" msprop:Generator_ColumnPropNameInTable="CreatTimeColumn" msprop:Generator_UserColumnName="CreatTime" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Xs_Order" />
      <xs:field xpath="mstns:OrderId" />
    </xs:unique>
    <xs:unique name="Xs_OrderDetail_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Xs_OrderDetail" />
      <xs:field xpath="mstns:OrderDetailId" />
    </xs:unique>
    <xs:unique name="Employee_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Employee" />
      <xs:field xpath="mstns:EmployeeNum" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Xs_OrderDetail_Xs_Order" msdata:parent="Xs_Order" msdata:child="Xs_OrderDetail" msdata:parentkey="OrderId" msdata:childkey="OrderId" msprop:Generator_UserChildTable="Xs_OrderDetail" msprop:Generator_ChildPropName="GetXs_OrderDetailRows" msprop:Generator_UserParentTable="Xs_Order" msprop:Generator_UserRelationName="FK_Xs_OrderDetail_Xs_Order" msprop:Generator_RelationVarName="relationFK_Xs_OrderDetail_Xs_Order" msprop:Generator_ParentPropName="Xs_OrderRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>